Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# PERMIT_READ

A program that you write and that Oracle OLAP checks for by name when an AW ATTACH read-only statement executes. Depending on the value returned by the program, Oracle OLAP executes the code within the program after attaching the analytic workspace. Depending on the statements in the `permit_read` program the user is granted or denied access to specific objects or sets of object values. Within `permit_read` program, you can specify PERMIT commands that grant or restrict access to individual workspace objects. All of the objects referred to in a given `permit_read` must exist in the same analytic workspace.

Note: Oracle OLAP checks for other programs when a user attaches a workspace. See "Startup Programs" for more information.

Return Value

`BOOLEAN`

`TRUE` when Oracle OLAP has successfully set up and attached the analytic workspace; or `FALSE` when it has not or when the `permit_read` program has thrown an exception

Note: You are encouraged to use the normal return values rather than relying on exceptions to create a return value of `FALSE`.

Syntax

To define a program with the name `PERMIT_READ` use the syntax shown in DEFINE PROGRAM. Code the actual program as a user-defined function with the following argument.

PERMIT_READ (password)

Arguments

See AW ATTACH for an explanation of password. When a user specifies a password when attaching the analytic workspace, then the password is passed as an argument to the program for processing.

Examples

For examples of how attachment programs, see Example 8-14, "Startup Programs".